package com.fhyc.dto;


import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.baomidou.mybatisplus.annotation.TableField;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.util.Date;

@Data
public class FhCompareDTO {

    @ExcelProperty("区域")
    @ColumnWidth(15)
    private String qyName;

    @ExcelIgnore
    private Integer teamId;

    @ExcelIgnore
    private Integer id;

    @ExcelIgnore
    private String qyid;

    @ExcelProperty("参与方")
    @ColumnWidth(20)
    private String yccj;

    @ExcelIgnore
    @ExcelProperty("日期")
    @ColumnWidth(15)
    private Date ycrq;

    @ExcelProperty("日期")
    @ColumnWidth(15)
    private String  dataDate;

    /**
     * 批次
     */
    @ExcelIgnore
    @ExcelProperty("批次")
    @ColumnWidth(15)
    private String batch;

    @ExcelIgnore
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date sjrq;

    @ExcelIgnore
    @ExcelProperty("总电量")
    @ColumnWidth(15)
    private Double rdl;

    @ExcelProperty("预测准确率")
    @ColumnWidth(15)
    private Double accuracy;

    @ExcelProperty("平均负荷")
    @ColumnWidth(15)
    private Double avgFh;

    @ExcelProperty("最大负荷")
    @ColumnWidth(15)
    private Double maxFh;

    @ExcelProperty("最小负荷")
    @ColumnWidth(15)
    private Double minFh;

    @ExcelProperty("最大负荷时间")
    @ColumnWidth(25)
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date maxFhTime;

    @ExcelProperty("最小负荷时间")
    @ColumnWidth(25)
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date minFhTime;

    @ExcelIgnore
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createTime;

    @ExcelIgnore
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date updateTime;
}
